

ALTER  proc sp_deactivate_salesperson_list
@customerId int
as
begin
	declare @status_id int

	select @status_id = RelationshipStatus_ID from Customer_Relationship_Status where Name = 'Inactive'
	update Customer_SalesPerson_relationship set RelationshipStatus_ID = @status_id where Customer_ID = @customerId
	
end